﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CrazySongDataSet" targetNamespace="http://tempuri.org/CrazySongDataSet.xsd" xmlns:mstns="http://tempuri.org/CrazySongDataSet.xsd" xmlns="http://tempuri.org/CrazySongDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrazySongConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="CrazySongConnectionString (Settings)" PropertyReference="ApplicationSettings.CrazyKTVfromCashBox.Properties.Settings.GlobalReference.Default.CrazySongConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ktv_FavoriteTableAdapter" GeneratorDataComponentClassName="ktv_FavoriteTableAdapter" Name="ktv_Favorite" UserDataComponentName="ktv_FavoriteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrazySongConnectionString (Settings)" DbObjectName="ktv_Favorite" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ktv_Favorite` WHERE ((`User_Id` = ?) AND (`Song_Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_User_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="User_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ktv_Favorite` (`User_Id`, `Song_Id`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="User_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="User_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT User_Id, Song_Id FROM ktv_Favorite</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ktv_Favorite` SET `User_Id` = ?, `Song_Id` = ? WHERE ((`User_Id` = ?) AND (`Song_Id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="User_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="User_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_User_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="User_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="User_Id" DataSetColumn="User_Id" />
              <Mapping SourceColumn="Song_Id" DataSetColumn="Song_Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ktv_SingerTableAdapter" GeneratorDataComponentClassName="ktv_SingerTableAdapter" Name="ktv_Singer" UserDataComponentName="ktv_SingerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrazySongConnectionString (Settings)" DbObjectName="ktv_Singer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ktv_Singer` WHERE ((`Singer_Id` = ?) AND ((? = 1 AND `Singer_Name` IS NULL) OR (`Singer_Name` = ?)) AND ((? = 1 AND `Singer_Type` IS NULL) OR (`Singer_Type` = ?)) AND ((? = 1 AND `Singer_Spell` IS NULL) OR (`Singer_Spell` = ?)) AND ((? = 1 AND `Singer_Strokes` IS NULL) OR (`Singer_Strokes` = ?)) AND ((? = 1 AND `Singer_SpellNum` IS NULL) OR (`Singer_SpellNum` = ?)) AND ((? = 1 AND `Singer_PenStyle` IS NULL) OR (`Singer_PenStyle` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Singer_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Spell" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Strokes" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Singer_Strokes" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_SpellNum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_PenStyle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ktv_Singer` (`Singer_Id`, `Singer_Name`, `Singer_Type`, `Singer_Spell`, `Singer_Strokes`, `Singer_SpellNum`, `Singer_PenStyle`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Singer_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Singer_Strokes" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Singer_Id, Singer_Name, Singer_Type, Singer_Spell, Singer_Strokes, Singer_SpellNum, Singer_PenStyle FROM ktv_Singer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ktv_Singer` SET `Singer_Id` = ?, `Singer_Name` = ?, `Singer_Type` = ?, `Singer_Spell` = ?, `Singer_Strokes` = ?, `Singer_SpellNum` = ?, `Singer_PenStyle` = ? WHERE ((`Singer_Id` = ?) AND ((? = 1 AND `Singer_Name` IS NULL) OR (`Singer_Name` = ?)) AND ((? = 1 AND `Singer_Type` IS NULL) OR (`Singer_Type` = ?)) AND ((? = 1 AND `Singer_Spell` IS NULL) OR (`Singer_Spell` = ?)) AND ((? = 1 AND `Singer_Strokes` IS NULL) OR (`Singer_Strokes` = ?)) AND ((? = 1 AND `Singer_SpellNum` IS NULL) OR (`Singer_SpellNum` = ?)) AND ((? = 1 AND `Singer_PenStyle` IS NULL) OR (`Singer_PenStyle` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Singer_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Singer_Strokes" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Singer_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Singer_Id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Spell" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_Spell" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_Strokes" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Singer_Strokes" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Singer_Strokes" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_SpellNum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_SpellNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Singer_PenStyle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Singer_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Singer_PenStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Singer_Id" DataSetColumn="Singer_Id" />
              <Mapping SourceColumn="Singer_Name" DataSetColumn="Singer_Name" />
              <Mapping SourceColumn="Singer_Type" DataSetColumn="Singer_Type" />
              <Mapping SourceColumn="Singer_Spell" DataSetColumn="Singer_Spell" />
              <Mapping SourceColumn="Singer_Strokes" DataSetColumn="Singer_Strokes" />
              <Mapping SourceColumn="Singer_SpellNum" DataSetColumn="Singer_SpellNum" />
              <Mapping SourceColumn="Singer_PenStyle" DataSetColumn="Singer_PenStyle" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ktv_SongTableAdapter" GeneratorDataComponentClassName="ktv_SongTableAdapter" Name="ktv_Song" UserDataComponentName="ktv_SongTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrazySongConnectionString (Settings)" DbObjectName="ktv_Song" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ktv_Song` WHERE ((`Song_Id` = ?) AND ((? = 1 AND `Song_Path` IS NULL) OR (`Song_Path` = ?)) AND ((? = 1 AND `Song_SongName` IS NULL) OR (`Song_SongName` = ?)) AND ((? = 1 AND `Song_Singer` IS NULL) OR (`Song_Singer` = ?)) AND ((? = 1 AND `Song_Spell` IS NULL) OR (`Song_Spell` = ?)) AND ((? = 1 AND `Song_WordCount` IS NULL) OR (`Song_WordCount` = ?)) AND ((? = 1 AND `Song_Volume` IS NULL) OR (`Song_Volume` = ?)) AND ((? = 1 AND `Song_Track` IS NULL) OR (`Song_Track` = ?)) AND ((? = 1 AND `Song_Lang` IS NULL) OR (`Song_Lang` = ?)) AND ((? = 1 AND `Song_FileName` IS NULL) OR (`Song_FileName` = ?)) AND ((? = 1 AND `Song_PlayCount` IS NULL) OR (`Song_PlayCount` = ?)) AND ((? = 1 AND `Song_PlayState` IS NULL) OR (`Song_PlayState` = ?)) AND ((? = 1 AND `Song_CreatDate` IS NULL) OR (`Song_CreatDate` = ?)) AND ((? = 1 AND `Song_SingerType` IS NULL) OR (`Song_SingerType` = ?)) AND ((? = 1 AND `Song_SpellNum` IS NULL) OR (`Song_SpellNum` = ?)) AND ((? = 1 AND `Song_SongType` IS NULL) OR (`Song_SongType` = ?)) AND ((? = 1 AND `Song_SongStroke` IS NULL) OR (`Song_SongStroke` = ?)) AND ((? = 1 AND `Song_SongNameFuzzy` IS NULL) OR (`Song_SongNameFuzzy` = ?)) AND ((? = 1 AND `Song_SingerFuzzy` IS NULL) OR (`Song_SingerFuzzy` = ?)) AND ((? = 1 AND `Song_FuzzyVer` IS NULL) OR (`Song_FuzzyVer` = ?)) AND ((? = 1 AND `Song_MB` IS NULL) OR (`Song_MB` = ?)) AND ((? = 1 AND `DLspace` IS NULL) OR (`DLspace` = ?)) AND ((? = 1 AND `Epasswd` IS NULL) OR (`Epasswd` = ?)) AND ((? = 1 AND `imgpath` IS NULL) OR (`imgpath` = ?)) AND ((? = 1 AND `cashboxsongid` IS NULL) OR (`cashboxsongid` = ?)) AND ((? = 1 AND `cashboxdat` IS NULL) OR (`cashboxdat` = ?)) AND ((? = 1 AND `holidaysongid` IS NULL) OR (`holidaysongid` = ?)) AND ((? = 1 AND `Song_PenStyle` IS NULL) OR (`Song_PenStyle` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Path" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Path" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Singer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Singer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Spell" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_WordCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_WordCount" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_Volume" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Track" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_Track" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Lang" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Lang" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_FileName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_FileName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PlayState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_PlayState" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_CreatDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Song_CreatDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SingerType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Song_SingerType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SpellNum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongStroke" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Song_SongStroke" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongNameFuzzy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongNameFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SingerFuzzy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SingerFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_MB" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Song_MB" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DLspace" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DLspace" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Epasswd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Epasswd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_imgpath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_imgpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cashboxsongid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cashboxsongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cashboxdat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cashboxdat" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_holidaysongid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_holidaysongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PenStyle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ktv_Song` (`Song_Id`, `Song_Path`, `Song_SongName`, `Song_Singer`, `Song_Spell`, `Song_WordCount`, `Song_Volume`, `Song_Track`, `Song_Lang`, `Song_FileName`, `Song_PlayCount`, `Song_PlayState`, `Song_CreatDate`, `Song_SingerType`, `Song_SpellNum`, `Song_SongType`, `Song_SongStroke`, `Song_SongNameFuzzy`, `Song_SingerFuzzy`, `Song_FuzzyVer`, `Song_MB`, `DLspace`, `Epasswd`, `imgpath`, `cashboxsongid`, `cashboxdat`, `holidaysongid`, `Song_PenStyle`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Path" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Singer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_WordCount" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_Volume" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_Track" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Lang" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_FileName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_PlayState" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Song_CreatDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Song_SingerType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Song_SongStroke" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongNameFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SingerFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Song_MB" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DLspace" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Epasswd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="imgpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cashboxsongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cashboxdat" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="holidaysongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Song_Id, Song_Path, Song_SongName, Song_Singer, Song_Spell, Song_WordCount, Song_Volume, Song_Track, Song_Lang, Song_FileName, Song_PlayCount, Song_PlayState, Song_CreatDate, Song_SingerType, Song_SpellNum, Song_SongType, Song_SongStroke, Song_SongNameFuzzy, Song_SingerFuzzy, Song_FuzzyVer, Song_MB, DLspace, Epasswd, imgpath, cashboxsongid, cashboxdat, holidaysongid, Song_PenStyle FROM ktv_Song</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ktv_Song` SET `Song_Id` = ?, `Song_Path` = ?, `Song_SongName` = ?, `Song_Singer` = ?, `Song_Spell` = ?, `Song_WordCount` = ?, `Song_Volume` = ?, `Song_Track` = ?, `Song_Lang` = ?, `Song_FileName` = ?, `Song_PlayCount` = ?, `Song_PlayState` = ?, `Song_CreatDate` = ?, `Song_SingerType` = ?, `Song_SpellNum` = ?, `Song_SongType` = ?, `Song_SongStroke` = ?, `Song_SongNameFuzzy` = ?, `Song_SingerFuzzy` = ?, `Song_FuzzyVer` = ?, `Song_MB` = ?, `DLspace` = ?, `Epasswd` = ?, `imgpath` = ?, `cashboxsongid` = ?, `cashboxdat` = ?, `holidaysongid` = ?, `Song_PenStyle` = ? WHERE ((`Song_Id` = ?) AND ((? = 1 AND `Song_Path` IS NULL) OR (`Song_Path` = ?)) AND ((? = 1 AND `Song_SongName` IS NULL) OR (`Song_SongName` = ?)) AND ((? = 1 AND `Song_Singer` IS NULL) OR (`Song_Singer` = ?)) AND ((? = 1 AND `Song_Spell` IS NULL) OR (`Song_Spell` = ?)) AND ((? = 1 AND `Song_WordCount` IS NULL) OR (`Song_WordCount` = ?)) AND ((? = 1 AND `Song_Volume` IS NULL) OR (`Song_Volume` = ?)) AND ((? = 1 AND `Song_Track` IS NULL) OR (`Song_Track` = ?)) AND ((? = 1 AND `Song_Lang` IS NULL) OR (`Song_Lang` = ?)) AND ((? = 1 AND `Song_FileName` IS NULL) OR (`Song_FileName` = ?)) AND ((? = 1 AND `Song_PlayCount` IS NULL) OR (`Song_PlayCount` = ?)) AND ((? = 1 AND `Song_PlayState` IS NULL) OR (`Song_PlayState` = ?)) AND ((? = 1 AND `Song_CreatDate` IS NULL) OR (`Song_CreatDate` = ?)) AND ((? = 1 AND `Song_SingerType` IS NULL) OR (`Song_SingerType` = ?)) AND ((? = 1 AND `Song_SpellNum` IS NULL) OR (`Song_SpellNum` = ?)) AND ((? = 1 AND `Song_SongType` IS NULL) OR (`Song_SongType` = ?)) AND ((? = 1 AND `Song_SongStroke` IS NULL) OR (`Song_SongStroke` = ?)) AND ((? = 1 AND `Song_SongNameFuzzy` IS NULL) OR (`Song_SongNameFuzzy` = ?)) AND ((? = 1 AND `Song_SingerFuzzy` IS NULL) OR (`Song_SingerFuzzy` = ?)) AND ((? = 1 AND `Song_FuzzyVer` IS NULL) OR (`Song_FuzzyVer` = ?)) AND ((? = 1 AND `Song_MB` IS NULL) OR (`Song_MB` = ?)) AND ((? = 1 AND `DLspace` IS NULL) OR (`DLspace` = ?)) AND ((? = 1 AND `Epasswd` IS NULL) OR (`Epasswd` = ?)) AND ((? = 1 AND `imgpath` IS NULL) OR (`imgpath` = ?)) AND ((? = 1 AND `cashboxsongid` IS NULL) OR (`cashboxsongid` = ?)) AND ((? = 1 AND `cashboxdat` IS NULL) OR (`cashboxdat` = ?)) AND ((? = 1 AND `holidaysongid` IS NULL) OR (`holidaysongid` = ?)) AND ((? = 1 AND `Song_PenStyle` IS NULL) OR (`Song_PenStyle` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Path" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Singer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_WordCount" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_Volume" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_Track" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_Lang" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_FileName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Song_PlayState" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Song_CreatDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Song_SingerType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Song_SongStroke" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SongNameFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_SingerFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Song_MB" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DLspace" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Epasswd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="imgpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="cashboxsongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="cashboxdat" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="holidaysongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Song_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Id" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Path" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Path" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Path" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Singer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Singer" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Singer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Spell" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Spell" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Spell" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_WordCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_WordCount" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_WordCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Volume" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_Volume" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Volume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Track" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_Track" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_Track" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_Lang" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_Lang" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_Lang" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_FileName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_FileName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_FileName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Song_PlayCount" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PlayState" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Song_PlayState" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Song_PlayState" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_CreatDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_Song_CreatDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Song_CreatDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SingerType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Song_SingerType" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SingerType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SpellNum" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SpellNum" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SpellNum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongStroke" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Song_SongStroke" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Song_SongStroke" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SongNameFuzzy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SongNameFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SongNameFuzzy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_SingerFuzzy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_SingerFuzzy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_SingerFuzzy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Song_FuzzyVer" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_FuzzyVer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_MB" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Song_MB" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Song_MB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DLspace" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DLspace" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DLspace" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Epasswd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Epasswd" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Epasswd" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_imgpath" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_imgpath" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="imgpath" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cashboxsongid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_cashboxsongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="cashboxsongid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_cashboxdat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_cashboxdat" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="cashboxdat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_holidaysongid" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_holidaysongid" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="holidaysongid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Song_PenStyle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Song_PenStyle" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Song_PenStyle" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Song_Id" DataSetColumn="Song_Id" />
              <Mapping SourceColumn="Song_Path" DataSetColumn="Song_Path" />
              <Mapping SourceColumn="Song_SongName" DataSetColumn="Song_SongName" />
              <Mapping SourceColumn="Song_Singer" DataSetColumn="Song_Singer" />
              <Mapping SourceColumn="Song_Spell" DataSetColumn="Song_Spell" />
              <Mapping SourceColumn="Song_WordCount" DataSetColumn="Song_WordCount" />
              <Mapping SourceColumn="Song_Volume" DataSetColumn="Song_Volume" />
              <Mapping SourceColumn="Song_Track" DataSetColumn="Song_Track" />
              <Mapping SourceColumn="Song_Lang" DataSetColumn="Song_Lang" />
              <Mapping SourceColumn="Song_FileName" DataSetColumn="Song_FileName" />
              <Mapping SourceColumn="Song_PlayCount" DataSetColumn="Song_PlayCount" />
              <Mapping SourceColumn="Song_PlayState" DataSetColumn="Song_PlayState" />
              <Mapping SourceColumn="Song_CreatDate" DataSetColumn="Song_CreatDate" />
              <Mapping SourceColumn="Song_SingerType" DataSetColumn="Song_SingerType" />
              <Mapping SourceColumn="Song_SpellNum" DataSetColumn="Song_SpellNum" />
              <Mapping SourceColumn="Song_SongType" DataSetColumn="Song_SongType" />
              <Mapping SourceColumn="Song_SongStroke" DataSetColumn="Song_SongStroke" />
              <Mapping SourceColumn="Song_SongNameFuzzy" DataSetColumn="Song_SongNameFuzzy" />
              <Mapping SourceColumn="Song_SingerFuzzy" DataSetColumn="Song_SingerFuzzy" />
              <Mapping SourceColumn="Song_FuzzyVer" DataSetColumn="Song_FuzzyVer" />
              <Mapping SourceColumn="Song_MB" DataSetColumn="Song_MB" />
              <Mapping SourceColumn="DLspace" DataSetColumn="DLspace" />
              <Mapping SourceColumn="Epasswd" DataSetColumn="Epasswd" />
              <Mapping SourceColumn="imgpath" DataSetColumn="imgpath" />
              <Mapping SourceColumn="cashboxsongid" DataSetColumn="cashboxsongid" />
              <Mapping SourceColumn="cashboxdat" DataSetColumn="cashboxdat" />
              <Mapping SourceColumn="holidaysongid" DataSetColumn="holidaysongid" />
              <Mapping SourceColumn="Song_PenStyle" DataSetColumn="Song_PenStyle" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ext_CashBoxTableAdapter" GeneratorDataComponentClassName="ext_CashBoxTableAdapter" Name="ext_CashBox" UserDataComponentName="ext_CashBoxTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrazySongConnectionString (Settings)" DbObjectName="ext_CashBox" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ext_CashBox` (`cashbox_id`, `song_lang`, `song_name`, `singer_name`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="cashbox_id" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="cashbox_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="song_lang" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="song_lang" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="song_name" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="song_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="singer_name" Precision="0" ProviderType="WChar" Scale="0" Size="0" SourceColumn="singer_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cashbox_id, song_lang, song_name, singer_name
FROM            ext_CashBox</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="cashbox_id" DataSetColumn="cashbox_id" />
              <Mapping SourceColumn="song_lang" DataSetColumn="song_lang" />
              <Mapping SourceColumn="song_name" DataSetColumn="song_name" />
              <Mapping SourceColumn="singer_name" DataSetColumn="singer_name" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CrazySongDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="CrazySongDataSet" msprop:Generator_UserDSName="CrazySongDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ktv_Favorite" msprop:Generator_TableClassName="ktv_FavoriteDataTable" msprop:Generator_TableVarName="tablektv_Favorite" msprop:Generator_TablePropName="ktv_Favorite" msprop:Generator_RowDeletingName="ktv_FavoriteRowDeleting" msprop:Generator_UserTableName="ktv_Favorite" msprop:Generator_RowChangingName="ktv_FavoriteRowChanging" msprop:Generator_RowEvHandlerName="ktv_FavoriteRowChangeEventHandler" msprop:Generator_RowDeletedName="ktv_FavoriteRowDeleted" msprop:Generator_RowEvArgName="ktv_FavoriteRowChangeEvent" msprop:Generator_RowChangedName="ktv_FavoriteRowChanged" msprop:Generator_RowClassName="ktv_FavoriteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="User_Id" msprop:Generator_ColumnVarNameInTable="columnUser_Id" msprop:Generator_ColumnPropNameInRow="User_Id" msprop:Generator_ColumnPropNameInTable="User_IdColumn" msprop:Generator_UserColumnName="User_Id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_Id" msprop:Generator_ColumnVarNameInTable="columnSong_Id" msprop:Generator_ColumnPropNameInRow="Song_Id" msprop:Generator_ColumnPropNameInTable="Song_IdColumn" msprop:Generator_UserColumnName="Song_Id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ktv_Singer" msprop:Generator_TableClassName="ktv_SingerDataTable" msprop:Generator_TableVarName="tablektv_Singer" msprop:Generator_TablePropName="ktv_Singer" msprop:Generator_RowDeletingName="ktv_SingerRowDeleting" msprop:Generator_UserTableName="ktv_Singer" msprop:Generator_RowChangingName="ktv_SingerRowChanging" msprop:Generator_RowEvHandlerName="ktv_SingerRowChangeEventHandler" msprop:Generator_RowDeletedName="ktv_SingerRowDeleted" msprop:Generator_RowEvArgName="ktv_SingerRowChangeEvent" msprop:Generator_RowChangedName="ktv_SingerRowChanged" msprop:Generator_RowClassName="ktv_SingerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Singer_Id" msprop:Generator_ColumnVarNameInTable="columnSinger_Id" msprop:Generator_ColumnPropNameInRow="Singer_Id" msprop:Generator_ColumnPropNameInTable="Singer_IdColumn" msprop:Generator_UserColumnName="Singer_Id" type="xs:int" />
              <xs:element name="Singer_Name" msprop:Generator_ColumnVarNameInTable="columnSinger_Name" msprop:Generator_ColumnPropNameInRow="Singer_Name" msprop:Generator_ColumnPropNameInTable="Singer_NameColumn" msprop:Generator_UserColumnName="Singer_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Singer_Type" msprop:Generator_ColumnVarNameInTable="columnSinger_Type" msprop:Generator_ColumnPropNameInRow="Singer_Type" msprop:Generator_ColumnPropNameInTable="Singer_TypeColumn" msprop:Generator_UserColumnName="Singer_Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Singer_Spell" msprop:Generator_ColumnVarNameInTable="columnSinger_Spell" msprop:Generator_ColumnPropNameInRow="Singer_Spell" msprop:Generator_ColumnPropNameInTable="Singer_SpellColumn" msprop:Generator_UserColumnName="Singer_Spell" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Singer_Strokes" msprop:Generator_ColumnVarNameInTable="columnSinger_Strokes" msprop:Generator_ColumnPropNameInRow="Singer_Strokes" msprop:Generator_ColumnPropNameInTable="Singer_StrokesColumn" msprop:Generator_UserColumnName="Singer_Strokes" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Singer_SpellNum" msprop:Generator_ColumnVarNameInTable="columnSinger_SpellNum" msprop:Generator_ColumnPropNameInRow="Singer_SpellNum" msprop:Generator_ColumnPropNameInTable="Singer_SpellNumColumn" msprop:Generator_UserColumnName="Singer_SpellNum" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Singer_PenStyle" msprop:Generator_ColumnVarNameInTable="columnSinger_PenStyle" msprop:Generator_ColumnPropNameInRow="Singer_PenStyle" msprop:Generator_ColumnPropNameInTable="Singer_PenStyleColumn" msprop:Generator_UserColumnName="Singer_PenStyle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ktv_Song" msprop:Generator_TableClassName="ktv_SongDataTable" msprop:Generator_TableVarName="tablektv_Song" msprop:Generator_TablePropName="ktv_Song" msprop:Generator_RowDeletingName="ktv_SongRowDeleting" msprop:Generator_UserTableName="ktv_Song" msprop:Generator_RowChangingName="ktv_SongRowChanging" msprop:Generator_RowEvHandlerName="ktv_SongRowChangeEventHandler" msprop:Generator_RowDeletedName="ktv_SongRowDeleted" msprop:Generator_RowEvArgName="ktv_SongRowChangeEvent" msprop:Generator_RowChangedName="ktv_SongRowChanged" msprop:Generator_RowClassName="ktv_SongRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Song_Id" msprop:Generator_ColumnVarNameInTable="columnSong_Id" msprop:Generator_ColumnPropNameInRow="Song_Id" msprop:Generator_ColumnPropNameInTable="Song_IdColumn" msprop:Generator_UserColumnName="Song_Id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_Path" msprop:Generator_ColumnVarNameInTable="columnSong_Path" msprop:Generator_ColumnPropNameInRow="Song_Path" msprop:Generator_ColumnPropNameInTable="Song_PathColumn" msprop:Generator_UserColumnName="Song_Path" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_SongName" msprop:Generator_ColumnVarNameInTable="columnSong_SongName" msprop:Generator_ColumnPropNameInRow="Song_SongName" msprop:Generator_ColumnPropNameInTable="Song_SongNameColumn" msprop:Generator_UserColumnName="Song_SongName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_Singer" msprop:Generator_ColumnVarNameInTable="columnSong_Singer" msprop:Generator_ColumnPropNameInRow="Song_Singer" msprop:Generator_ColumnPropNameInTable="Song_SingerColumn" msprop:Generator_UserColumnName="Song_Singer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_Spell" msprop:Generator_ColumnVarNameInTable="columnSong_Spell" msprop:Generator_ColumnPropNameInRow="Song_Spell" msprop:Generator_ColumnPropNameInTable="Song_SpellColumn" msprop:Generator_UserColumnName="Song_Spell" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_WordCount" msprop:Generator_ColumnVarNameInTable="columnSong_WordCount" msprop:Generator_ColumnPropNameInRow="Song_WordCount" msprop:Generator_ColumnPropNameInTable="Song_WordCountColumn" msprop:Generator_UserColumnName="Song_WordCount" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Song_Volume" msprop:Generator_ColumnVarNameInTable="columnSong_Volume" msprop:Generator_ColumnPropNameInRow="Song_Volume" msprop:Generator_ColumnPropNameInTable="Song_VolumeColumn" msprop:Generator_UserColumnName="Song_Volume" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Song_Track" msprop:Generator_ColumnVarNameInTable="columnSong_Track" msprop:Generator_ColumnPropNameInRow="Song_Track" msprop:Generator_ColumnPropNameInTable="Song_TrackColumn" msprop:Generator_UserColumnName="Song_Track" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Song_Lang" msprop:Generator_ColumnVarNameInTable="columnSong_Lang" msprop:Generator_ColumnPropNameInRow="Song_Lang" msprop:Generator_ColumnPropNameInTable="Song_LangColumn" msprop:Generator_UserColumnName="Song_Lang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_FileName" msprop:Generator_ColumnVarNameInTable="columnSong_FileName" msprop:Generator_ColumnPropNameInRow="Song_FileName" msprop:Generator_ColumnPropNameInTable="Song_FileNameColumn" msprop:Generator_UserColumnName="Song_FileName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_PlayCount" msprop:Generator_ColumnVarNameInTable="columnSong_PlayCount" msprop:Generator_ColumnPropNameInRow="Song_PlayCount" msprop:Generator_ColumnPropNameInTable="Song_PlayCountColumn" msprop:Generator_UserColumnName="Song_PlayCount" type="xs:int" minOccurs="0" />
              <xs:element name="Song_PlayState" msprop:Generator_ColumnVarNameInTable="columnSong_PlayState" msprop:Generator_ColumnPropNameInRow="Song_PlayState" msprop:Generator_ColumnPropNameInTable="Song_PlayStateColumn" msprop:Generator_UserColumnName="Song_PlayState" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Song_CreatDate" msprop:Generator_ColumnVarNameInTable="columnSong_CreatDate" msprop:Generator_ColumnPropNameInRow="Song_CreatDate" msprop:Generator_ColumnPropNameInTable="Song_CreatDateColumn" msprop:Generator_UserColumnName="Song_CreatDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Song_SingerType" msprop:Generator_ColumnVarNameInTable="columnSong_SingerType" msprop:Generator_ColumnPropNameInRow="Song_SingerType" msprop:Generator_ColumnPropNameInTable="Song_SingerTypeColumn" msprop:Generator_UserColumnName="Song_SingerType" type="xs:short" minOccurs="0" />
              <xs:element name="Song_SpellNum" msprop:Generator_ColumnVarNameInTable="columnSong_SpellNum" msprop:Generator_ColumnPropNameInRow="Song_SpellNum" msprop:Generator_ColumnPropNameInTable="Song_SpellNumColumn" msprop:Generator_UserColumnName="Song_SpellNum" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_SongType" msprop:Generator_ColumnVarNameInTable="columnSong_SongType" msprop:Generator_ColumnPropNameInRow="Song_SongType" msprop:Generator_ColumnPropNameInTable="Song_SongTypeColumn" msprop:Generator_UserColumnName="Song_SongType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_SongStroke" msprop:Generator_ColumnVarNameInTable="columnSong_SongStroke" msprop:Generator_ColumnPropNameInRow="Song_SongStroke" msprop:Generator_ColumnPropNameInTable="Song_SongStrokeColumn" msprop:Generator_UserColumnName="Song_SongStroke" type="xs:short" minOccurs="0" />
              <xs:element name="Song_SongNameFuzzy" msprop:Generator_ColumnVarNameInTable="columnSong_SongNameFuzzy" msprop:Generator_ColumnPropNameInRow="Song_SongNameFuzzy" msprop:Generator_ColumnPropNameInTable="Song_SongNameFuzzyColumn" msprop:Generator_UserColumnName="Song_SongNameFuzzy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="60" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_SingerFuzzy" msprop:Generator_ColumnVarNameInTable="columnSong_SingerFuzzy" msprop:Generator_ColumnPropNameInRow="Song_SingerFuzzy" msprop:Generator_ColumnPropNameInTable="Song_SingerFuzzyColumn" msprop:Generator_UserColumnName="Song_SingerFuzzy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_FuzzyVer" msprop:Generator_ColumnVarNameInTable="columnSong_FuzzyVer" msprop:Generator_ColumnPropNameInRow="Song_FuzzyVer" msprop:Generator_ColumnPropNameInTable="Song_FuzzyVerColumn" msprop:Generator_UserColumnName="Song_FuzzyVer" type="xs:int" minOccurs="0" />
              <xs:element name="Song_MB" msprop:Generator_ColumnVarNameInTable="columnSong_MB" msprop:Generator_ColumnPropNameInRow="Song_MB" msprop:Generator_ColumnPropNameInTable="Song_MBColumn" msprop:Generator_UserColumnName="Song_MB" type="xs:float" minOccurs="0" />
              <xs:element name="DLspace" msprop:Generator_ColumnVarNameInTable="columnDLspace" msprop:Generator_ColumnPropNameInRow="DLspace" msprop:Generator_ColumnPropNameInTable="DLspaceColumn" msprop:Generator_UserColumnName="DLspace" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Epasswd" msprop:Generator_ColumnVarNameInTable="columnEpasswd" msprop:Generator_ColumnPropNameInRow="Epasswd" msprop:Generator_ColumnPropNameInTable="EpasswdColumn" msprop:Generator_UserColumnName="Epasswd" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="imgpath" msprop:Generator_ColumnVarNameInTable="columnimgpath" msprop:Generator_ColumnPropNameInRow="imgpath" msprop:Generator_ColumnPropNameInTable="imgpathColumn" msprop:Generator_UserColumnName="imgpath" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cashboxsongid" msprop:Generator_ColumnVarNameInTable="columncashboxsongid" msprop:Generator_ColumnPropNameInRow="cashboxsongid" msprop:Generator_ColumnPropNameInTable="cashboxsongidColumn" msprop:Generator_UserColumnName="cashboxsongid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cashboxdat" msprop:Generator_ColumnVarNameInTable="columncashboxdat" msprop:Generator_ColumnPropNameInRow="cashboxdat" msprop:Generator_ColumnPropNameInTable="cashboxdatColumn" msprop:Generator_UserColumnName="cashboxdat" type="xs:dateTime" minOccurs="0" />
              <xs:element name="holidaysongid" msprop:Generator_ColumnVarNameInTable="columnholidaysongid" msprop:Generator_ColumnPropNameInRow="holidaysongid" msprop:Generator_ColumnPropNameInTable="holidaysongidColumn" msprop:Generator_UserColumnName="holidaysongid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Song_PenStyle" msprop:Generator_ColumnVarNameInTable="columnSong_PenStyle" msprop:Generator_ColumnPropNameInRow="Song_PenStyle" msprop:Generator_ColumnPropNameInTable="Song_PenStyleColumn" msprop:Generator_UserColumnName="Song_PenStyle" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ext_CashBox" msprop:Generator_TableClassName="ext_CashBoxDataTable" msprop:Generator_TableVarName="tableext_CashBox" msprop:Generator_TablePropName="ext_CashBox" msprop:Generator_RowDeletingName="ext_CashBoxRowDeleting" msprop:Generator_UserTableName="ext_CashBox" msprop:Generator_RowChangingName="ext_CashBoxRowChanging" msprop:Generator_RowEvHandlerName="ext_CashBoxRowChangeEventHandler" msprop:Generator_RowDeletedName="ext_CashBoxRowDeleted" msprop:Generator_RowEvArgName="ext_CashBoxRowChangeEvent" msprop:Generator_RowChangedName="ext_CashBoxRowChanged" msprop:Generator_RowClassName="ext_CashBoxRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="cashbox_id" msprop:Generator_ColumnVarNameInTable="columncashbox_id" msprop:Generator_ColumnPropNameInRow="cashbox_id" msprop:Generator_ColumnPropNameInTable="cashbox_idColumn" msprop:Generator_UserColumnName="cashbox_id" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="song_lang" msprop:Generator_ColumnVarNameInTable="columnsong_lang" msprop:Generator_ColumnPropNameInRow="song_lang" msprop:Generator_ColumnPropNameInTable="song_langColumn" msprop:Generator_UserColumnName="song_lang" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="song_name" msprop:Generator_ColumnVarNameInTable="columnsong_name" msprop:Generator_ColumnPropNameInRow="song_name" msprop:Generator_ColumnPropNameInTable="song_nameColumn" msprop:Generator_UserColumnName="song_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="singer_name" msprop:Generator_ColumnVarNameInTable="columnsinger_name" msprop:Generator_ColumnPropNameInRow="singer_name" msprop:Generator_ColumnPropNameInTable="singer_nameColumn" msprop:Generator_UserColumnName="singer_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="createDate" msprop:Generator_ColumnVarNameInTable="columncreateDate" msprop:Generator_ColumnPropNameInRow="createDate" msprop:Generator_ColumnPropNameInTable="createDateColumn" msprop:Generator_UserColumnName="createDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ktv_Favorite" />
      <xs:field xpath="mstns:User_Id" />
      <xs:field xpath="mstns:Song_Id" />
    </xs:unique>
    <xs:unique name="ktv_Singer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ktv_Singer" />
      <xs:field xpath="mstns:Singer_Id" />
    </xs:unique>
    <xs:unique name="ktv_Song_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ktv_Song" />
      <xs:field xpath="mstns:Song_Id" />
    </xs:unique>
  </xs:element>
</xs:schema>